USE [influenza]
GO

/****** Object:  StoredProcedure [dbo].[SP_GuardaAvisos]    Script Date: 12/30/2009 20:10:30 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[SP_GuardaAvisos]
@aviso varchar(255),
@id_usuario varchar(10)
as
Begin

declare @qry varchar(255)

update dat_avisos set activo=0

set @qry='insert into dat_avisos values('''+@aviso+''',getdate(),1,1,'+@id_usuario+')'
exec (@qry)
End
GO

